﻿CREATE PROCEDURE [dbo].[yaf_forum_moderators]
AS
    BEGIN
        SELECT a.ForumID,
               a.GroupID,
               GroupName = b.Name
        FROM   yaf_ForumAccess a,
               yaf_Group b,
               yaf_AccessMask c
        WHERE  (c.Flags & 64) <> 0
        AND b.GroupID = a.GroupID
        AND c.AccessMaskID = a.AccessMaskID
    END


